insert into countries(short_name, long_name, inactive) values('AF', 'Afghanistan', 0);
insert into countries(short_name, long_name, inactive) values('AL', 'Albania', 0);
insert into countries(short_name, long_name, inactive) values('DZ', 'Algeria', 0);
insert into countries(short_name, long_name, inactive) values('AS', 'American Samoa', 0);
insert into countries(short_name, long_name, inactive) values('AD', 'Andorra', 0);
insert into countries(short_name, long_name, inactive) values('AO', 'Angola', 0);
insert into countries(short_name, long_name, inactive) values('AI', 'Anguilla', 0);
insert into countries(short_name, long_name, inactive) values('AQ', 'Antarctica', 0);
insert into countries(short_name, long_name, inactive) values('AG', 'Antigua And Barbuda', 0);
insert into countries(short_name, long_name, inactive) values('AR', 'Argentina', 0);
insert into countries(short_name, long_name, inactive) values('AM', 'Armenia', 0);
insert into countries(short_name, long_name, inactive) values('AW', 'Aruba', 0);
insert into countries(short_name, long_name, inactive) values('AU', 'Australia', 0);
insert into countries(short_name, long_name, inactive) values('AT', 'Austria', 0);
insert into countries(short_name, long_name, inactive) values('AZ', 'Azerbaijan', 0);
insert into countries(short_name, long_name, inactive) values('BS', 'Bahamas', 0);
insert into countries(short_name, long_name, inactive) values('BH', 'Bahrain', 0);
insert into countries(short_name, long_name, inactive) values('BD', 'Bangladesh', 0);
insert into countries(short_name, long_name, inactive) values('BB', 'Barbados', 0);
insert into countries(short_name, long_name, inactive) values('BY', 'Belarus', 0);
insert into countries(short_name, long_name, inactive) values('BE', 'Belgium', 0);
insert into countries(short_name, long_name, inactive) values('BZ', 'Belize', 0);
insert into countries(short_name, long_name, inactive) values('BJ', 'Benin', 0);
insert into countries(short_name, long_name, inactive) values('BM', 'Bermuda', 0);
insert into countries(short_name, long_name, inactive) values('BT', 'Bhutan', 0);
insert into countries(short_name, long_name, inactive) values('BO', 'Bolivia', 0);
insert into countries(short_name, long_name, inactive) values('BA', 'Bosnia And Herzegovina', 0);
insert into countries(short_name, long_name, inactive) values('BW', 'Botswana', 0);
insert into countries(short_name, long_name, inactive) values('BV', 'Bouvet Island', 0);
insert into countries(short_name, long_name, inactive) values('BR', 'Brazil', 0);
insert into countries(short_name, long_name, inactive) values('IO', 'British Indian Ocean Territory', 0);
insert into countries(short_name, long_name, inactive) values('VG', 'British Virgin Islands', 0);
insert into countries(short_name, long_name, inactive) values('BN', 'Brunei Darussalam', 0);
insert into countries(short_name, long_name, inactive) values('BG', 'Bulgaria', 0);
insert into countries(short_name, long_name, inactive) values('BF', 'Burkina Faso', 0);
insert into countries(short_name, long_name, inactive) values('BI', 'Burundi', 0);
insert into countries(short_name, long_name, inactive) values('KH', 'Cambodia', 0);
insert into countries(short_name, long_name, inactive) values('CM', 'Cameroon', 0);
insert into countries(short_name, long_name, inactive) values('CA', 'Canada', 0);
insert into countries(short_name, long_name, inactive) values('CV', 'Cape Verde', 0);
insert into countries(short_name, long_name, inactive) values('KY', 'Cayman Islands', 0);
insert into countries(short_name, long_name, inactive) values('CF', 'Central African Republic', 0);
insert into countries(short_name, long_name, inactive) values('TD', 'Chad', 0);
insert into countries(short_name, long_name, inactive) values('CL', 'Chile', 0);
insert into countries(short_name, long_name, inactive) values('CN', 'China', 0);
insert into countries(short_name, long_name, inactive) values('CX', 'Christmas Island', 0);
insert into countries(short_name, long_name, inactive) values('CC', 'Cocos (Keeling) Islands', 0);
insert into countries(short_name, long_name, inactive) values('CO', 'Colombia', 0);
insert into countries(short_name, long_name, inactive) values('KM', 'Comoros', 0);
insert into countries(short_name, long_name, inactive) values('CG', 'Congo', 0);
insert into countries(short_name, long_name, inactive) values('CD', 'Congo, The Democratic Republic Of', 0);
insert into countries(short_name, long_name, inactive) values('CK', 'Cook Islands', 0);
insert into countries(short_name, long_name, inactive) values('CR', 'Costa Rica', 0);
insert into countries(short_name, long_name, inactive) values('HR', 'Croatia', 0);
insert into countries(short_name, long_name, inactive) values('CU', 'Cuba', 0);
insert into countries(short_name, long_name, inactive) values('CY', 'Cyprus', 0);
insert into countries(short_name, long_name, inactive) values('CZ', 'Czech Republic', 0);
insert into countries(short_name, long_name, inactive) values('DK', 'Denmark', 0);
insert into countries(short_name, long_name, inactive) values('DJ', 'Djibouti', 0);
insert into countries(short_name, long_name, inactive) values('DM', 'Dominica', 0);
insert into countries(short_name, long_name, inactive) values('DO', 'Dominican Republic', 0);
insert into countries(short_name, long_name, inactive) values('TP', 'East Timor', 0);
insert into countries(short_name, long_name, inactive) values('EC', 'Ecuador', 0);
insert into countries(short_name, long_name, inactive) values('EG', 'Egypt', 0);
insert into countries(short_name, long_name, inactive) values('SV', 'El Salvador', 0);
insert into countries(short_name, long_name, inactive) values('GQ', 'Equatorial Guinea', 0);
insert into countries(short_name, long_name, inactive) values('ER', 'Eritrea', 0);
insert into countries(short_name, long_name, inactive) values('EE', 'Estonia', 0);
insert into countries(short_name, long_name, inactive) values('ET', 'Ethiopia', 0);
insert into countries(short_name, long_name, inactive) values('FK', 'Falkland Islands (Malvinas)', 0);
insert into countries(short_name, long_name, inactive) values('FO', 'Faroe Islands', 0);
insert into countries(short_name, long_name, inactive) values('FJ', 'Fiji', 0);
insert into countries(short_name, long_name, inactive) values('FI', 'Finland', 0);
insert into countries(short_name, long_name, inactive) values('FR', 'France', 0);
insert into countries(short_name, long_name, inactive) values('GF', 'French Guiana', 0);
insert into countries(short_name, long_name, inactive) values('PF', 'French Polynesia', 0);
insert into countries(short_name, long_name, inactive) values('TF', 'French Southern Territories', 0);
insert into countries(short_name, long_name, inactive) values('GA', 'Gabon', 0);
insert into countries(short_name, long_name, inactive) values('GM', 'Gambia', 0);
insert into countries(short_name, long_name, inactive) values('GE', 'Georgia', 0);
insert into countries(short_name, long_name, inactive) values('DE', 'Germany', 0);
insert into countries(short_name, long_name, inactive) values('GH', 'Ghana', 0);
insert into countries(short_name, long_name, inactive) values('GI', 'Gibraltar', 0);
insert into countries(short_name, long_name, inactive) values('GR', 'Greece', 0);
insert into countries(short_name, long_name, inactive) values('GL', 'Greenland', 0);
insert into countries(short_name, long_name, inactive) values('GD', 'Grenada', 0);
insert into countries(short_name, long_name, inactive) values('GP', 'Guadeloupe', 0);
insert into countries(short_name, long_name, inactive) values('GU', 'Guam', 0);
insert into countries(short_name, long_name, inactive) values('GT', 'Guatemala', 0);
insert into countries(short_name, long_name, inactive) values('GN', 'Guinea', 0);
insert into countries(short_name, long_name, inactive) values('GW', 'Guinea-Bissau', 0);
insert into countries(short_name, long_name, inactive) values('GY', 'Guyana', 0);
insert into countries(short_name, long_name, inactive) values('HT', 'Haiti', 0);
insert into countries(short_name, long_name, inactive) values('HM', 'Heard Island And Mcdonald Islands', 0);
insert into countries(short_name, long_name, inactive) values('VA', 'Holy See (Vatican City State)', 0);
insert into countries(short_name, long_name, inactive) values('HN', 'Honduras', 0);
insert into countries(short_name, long_name, inactive) values('HK', 'Hong Kong', 0);
insert into countries(short_name, long_name, inactive) values('HU', 'Hungary', 0);
insert into countries(short_name, long_name, inactive) values('IS', 'Iceland', 0);
insert into countries(short_name, long_name, inactive) values('IN', 'India', 0);
insert into countries(short_name, long_name, inactive) values('ID', 'Indonesia', 0);
insert into countries(short_name, long_name, inactive) values('IR', 'Iran', 0);
insert into countries(short_name, long_name, inactive) values('IQ', 'Iraq', 0);
insert into countries(short_name, long_name, inactive) values('IE', 'Ireland', 0);
insert into countries(short_name, long_name, inactive) values('IL', 'Israel', 0);
insert into countries(short_name, long_name, inactive) values('IT', 'Italy', 0);
insert into countries(short_name, long_name, inactive) values('CI', 'Ivory Coast', 0);
insert into countries(short_name, long_name, inactive) values('JM', 'Jamaica', 0);
insert into countries(short_name, long_name, inactive) values('JP', 'Japan', 0);
insert into countries(short_name, long_name, inactive) values('JO', 'Jordan', 0);
insert into countries(short_name, long_name, inactive) values('KZ', 'Kazakhstan', 0);
insert into countries(short_name, long_name, inactive) values('KE', 'Kenya', 0);
insert into countries(short_name, long_name, inactive) values('KI', 'Kiribati', 0);
insert into countries(short_name, long_name, inactive) values('KP', 'Korea, Democratic Peoples Republic Of', 0);
insert into countries(short_name, long_name, inactive) values('KR', 'Korea, Republic Of', 0);
insert into countries(short_name, long_name, inactive) values('KW', 'Kuwait', 0);
insert into countries(short_name, long_name, inactive) values('KG', 'Kyrgyzstan', 0);
insert into countries(short_name, long_name, inactive) values('LA', 'Laos', 0);
insert into countries(short_name, long_name, inactive) values('LV', 'Latvia', 0);
insert into countries(short_name, long_name, inactive) values('LB', 'Lebanon', 0);
insert into countries(short_name, long_name, inactive) values('LS', 'Lesotho', 0);
insert into countries(short_name, long_name, inactive) values('LR', 'Liberia', 0);
insert into countries(short_name, long_name, inactive) values('LY', 'Libyan Arab Jamahiriya', 0);
insert into countries(short_name, long_name, inactive) values('LI', 'Liechtenstein', 0);
insert into countries(short_name, long_name, inactive) values('LT', 'Lithuania', 0);
insert into countries(short_name, long_name, inactive) values('LU', 'Luxembourg', 0);
insert into countries(short_name, long_name, inactive) values('MO', 'Macao', 0);
insert into countries(short_name, long_name, inactive) values('MK', 'Macedonia, Former Yugoslav Republic Of', 0);
insert into countries(short_name, long_name, inactive) values('MG', 'Madagascar', 0);
insert into countries(short_name, long_name, inactive) values('MW', 'Malawi', 0);
insert into countries(short_name, long_name, inactive) values('MY', 'Malaysia', 0);
insert into countries(short_name, long_name, inactive) values('MV', 'Maldives', 0);
insert into countries(short_name, long_name, inactive) values('ML', 'Mali', 0);
insert into countries(short_name, long_name, inactive) values('MT', 'Malta', 0);
insert into countries(short_name, long_name, inactive) values('MH', 'Marshall Islands', 0);
insert into countries(short_name, long_name, inactive) values('MQ', 'Martinique', 0);
insert into countries(short_name, long_name, inactive) values('MR', 'Mauritania', 0);
insert into countries(short_name, long_name, inactive) values('MU', 'Mauritius', 0);
insert into countries(short_name, long_name, inactive) values('YT', 'Mayotte', 0);
insert into countries(short_name, long_name, inactive) values('MX', 'Mexico', 0);
insert into countries(short_name, long_name, inactive) values('FM', 'Micronesia, Federated States Of', 0);
insert into countries(short_name, long_name, inactive) values('MD', 'Moldova', 0);
insert into countries(short_name, long_name, inactive) values('MC', 'Monaco', 0);
insert into countries(short_name, long_name, inactive) values('MN', 'Mongolia', 0);
insert into countries(short_name, long_name, inactive) values('ME', 'Montenegro', 0);
insert into countries(short_name, long_name, inactive) values('MS', 'Montserrat', 0);
insert into countries(short_name, long_name, inactive) values('MA', 'Morocco', 0);
insert into countries(short_name, long_name, inactive) values('MZ', 'Mozambique', 0);
insert into countries(short_name, long_name, inactive) values('MM', 'Myanmar', 0);
insert into countries(short_name, long_name, inactive) values('NA', 'Namibia', 0);
insert into countries(short_name, long_name, inactive) values('NR', 'Nauru', 0);
insert into countries(short_name, long_name, inactive) values('NP', 'Nepal', 0);
insert into countries(short_name, long_name, inactive) values('NL', 'Netherlands', 0);
insert into countries(short_name, long_name, inactive) values('AN', 'Netherlands Antilles', 0);
insert into countries(short_name, long_name, inactive) values('NC', 'New Caledonia', 0);
insert into countries(short_name, long_name, inactive) values('NZ', 'New Zealand', 0);
insert into countries(short_name, long_name, inactive) values('NI', 'Nicaragua', 0);
insert into countries(short_name, long_name, inactive) values('NE', 'Niger', 0);
insert into countries(short_name, long_name, inactive) values('NG', 'Nigeria', 0);
insert into countries(short_name, long_name, inactive) values('NU', 'Niue', 0);
insert into countries(short_name, long_name, inactive) values('NF', 'Norfolk Island', 0);
insert into countries(short_name, long_name, inactive) values('MP', 'Northern Mariana Islands', 0);
insert into countries(short_name, long_name, inactive) values('NO', 'Norway', 0);
insert into countries(short_name, long_name, inactive) values('OM', 'Oman', 0);
insert into countries(short_name, long_name, inactive) values('PK', 'Pakistan', 0);
insert into countries(short_name, long_name, inactive) values('PW', 'Palau', 0);
insert into countries(short_name, long_name, inactive) values('PS', 'Palestinian Territories', 0);
insert into countries(short_name, long_name, inactive) values('PA', 'Panama', 0);
insert into countries(short_name, long_name, inactive) values('PG', 'Papua New Guinea', 0);
insert into countries(short_name, long_name, inactive) values('PY', 'Paraguay', 0);
insert into countries(short_name, long_name, inactive) values('PE', 'Peru', 0);
insert into countries(short_name, long_name, inactive) values('PH', 'Philippines', 0);
insert into countries(short_name, long_name, inactive) values('PN', 'Pitcairn', 0);
insert into countries(short_name, long_name, inactive) values('PL', 'Poland', 0);
insert into countries(short_name, long_name, inactive) values('PT', 'Portugal', 0);
insert into countries(short_name, long_name, inactive) values('PR', 'Puerto Rico', 0);
insert into countries(short_name, long_name, inactive) values('QA', 'Qatar', 0);
insert into countries(short_name, long_name, inactive) values('RE', 'Reunion', 0);
insert into countries(short_name, long_name, inactive) values('RO', 'Romania', 0);
insert into countries(short_name, long_name, inactive) values('RU', 'Russian Federation', 0);
insert into countries(short_name, long_name, inactive) values('RW', 'Rwanda', 0);
insert into countries(short_name, long_name, inactive) values('SH', 'Saint Helena', 0);
insert into countries(short_name, long_name, inactive) values('KN', 'Saint Kitts And Nevis', 0);
insert into countries(short_name, long_name, inactive) values('LC', 'Saint Lucia', 0);
insert into countries(short_name, long_name, inactive) values('PM', 'Saint Pierre And Miquelon', 0);
insert into countries(short_name, long_name, inactive) values('VC', 'Saint Vincent And The Grenadines', 0);
insert into countries(short_name, long_name, inactive) values('WS', 'Samoa', 0);
insert into countries(short_name, long_name, inactive) values('SM', 'San Marino', 0);
insert into countries(short_name, long_name, inactive) values('ST', 'Sao Tome And Principe', 0);
insert into countries(short_name, long_name, inactive) values('SA', 'Saudi Arabia', 0);
insert into countries(short_name, long_name, inactive) values('SN', 'Senegal', 0);
insert into countries(short_name, long_name, inactive) values('RS', 'Serbia', 0);
insert into countries(short_name, long_name, inactive) values('SC', 'Seychelles', 0);
insert into countries(short_name, long_name, inactive) values('SL', 'Sierra Leone', 0);
insert into countries(short_name, long_name, inactive) values('SG', 'Singapore', 0);
insert into countries(short_name, long_name, inactive) values('SK', 'Slovakia', 0);
insert into countries(short_name, long_name, inactive) values('SI', 'Slovenia', 0);
insert into countries(short_name, long_name, inactive) values('SB', 'Solomon Islands', 0);
insert into countries(short_name, long_name, inactive) values('SO', 'Somalia', 0);
insert into countries(short_name, long_name, inactive) values('ZA', 'South Africa', 0);
insert into countries(short_name, long_name, inactive) values('GS', 'South Georgia And The South Sandwich Islands', 0);
insert into countries(short_name, long_name, inactive) values('ES', 'Spain', 0);
insert into countries(short_name, long_name, inactive) values('LK', 'Sri Lanka', 0);
insert into countries(short_name, long_name, inactive) values('SD', 'Sudan', 0);
insert into countries(short_name, long_name, inactive) values('SR', 'Suriname', 0);
insert into countries(short_name, long_name, inactive) values('SJ', 'Svalbard And Jan Mayen', 0);
insert into countries(short_name, long_name, inactive) values('SZ', 'Swaziland', 0);
insert into countries(short_name, long_name, inactive) values('SE', 'Sweden', 0);
insert into countries(short_name, long_name, inactive) values('CH', 'Switzerland', 0);
insert into countries(short_name, long_name, inactive) values('SY', 'Syria', 0);
insert into countries(short_name, long_name, inactive) values('TW', 'Taiwan', 0);
insert into countries(short_name, long_name, inactive) values('TJ', 'Tajikistan', 0);
insert into countries(short_name, long_name, inactive) values('TZ', 'Tanzania', 0);
insert into countries(short_name, long_name, inactive) values('TH', 'Thailand', 0);
insert into countries(short_name, long_name, inactive) values('TL', 'Timor-Leste', 0);
insert into countries(short_name, long_name, inactive) values('TG', 'Togo', 0);
insert into countries(short_name, long_name, inactive) values('TK', 'Tokelau', 0);
insert into countries(short_name, long_name, inactive) values('TO', 'Tonga', 0);
insert into countries(short_name, long_name, inactive) values('TT', 'Trinidad And Tobago', 0);
insert into countries(short_name, long_name, inactive) values('TN', 'Tunisia', 0);
insert into countries(short_name, long_name, inactive) values('TR', 'Turkey', 0);
insert into countries(short_name, long_name, inactive) values('TM', 'Turkmenistan', 0);
insert into countries(short_name, long_name, inactive) values('TC', 'Turks And Caicos Islands', 0);
insert into countries(short_name, long_name, inactive) values('TV', 'Tuvalu', 0);
insert into countries(short_name, long_name, inactive) values('UG', 'Uganda', 0);
insert into countries(short_name, long_name, inactive) values('UA', 'Ukraine', 0);
insert into countries(short_name, long_name, inactive) values('AE', 'United Arab Emirates', 0);
insert into countries(short_name, long_name, inactive) values('UK', 'United Kingdom', 0);
insert into countries(short_name, long_name, inactive) values('US', 'United States', 0);
insert into countries(short_name, long_name, inactive) values('UY', 'Uruguay', 0);
insert into countries(short_name, long_name, inactive) values('UM', 'U.S. Minor Outlying Islands', 0);
insert into countries(short_name, long_name, inactive) values('VI', 'U.S. Virgin Islands', 0);
insert into countries(short_name, long_name, inactive) values('UZ', 'Uzbekistan', 0);
insert into countries(short_name, long_name, inactive) values('VU', 'Vanuatu', 0);
insert into countries(short_name, long_name, inactive) values('VE', 'Venezuela', 0);
insert into countries(short_name, long_name, inactive) values('VN', 'Viet Nam', 0);
insert into countries(short_name, long_name, inactive) values('WF', 'Wallis And Futuna', 0);
insert into countries(short_name, long_name, inactive) values('EH', 'Western Sahara', 0);
insert into countries(short_name, long_name, inactive) values('YE', 'Yemen', 0);
insert into countries(short_name, long_name, inactive) values('ZM', 'Zambia', 0);
insert into countries(short_name, long_name, inactive) values('ZW', 'Zimbabwe', 0);